/*
 Navicat Premium Data Transfer

 Source Server         : localmysql
 Source Server Type    : MySQL
 Source Server Version : 50718
 Source Host           : localhost
 Source Database       : bshop

 Target Server Type    : MySQL
 Target Server Version : 50718
 File Encoding         : utf-8

 Date: 11/02/2017 07:40:29 AM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `msm_code`
-- ----------------------------
DROP TABLE IF EXISTS `msm_code`;
CREATE TABLE `msm_code` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone` varchar(20) DEFAULT NULL,
  `code` varchar(20) DEFAULT NULL,
  `business` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `orderInfo`
-- ----------------------------
DROP TABLE IF EXISTS `orderInfo`;
CREATE TABLE `orderInfo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_Id` varchar(22) NOT NULL,
  `serial_num` bigint(22) DEFAULT NULL,
  `user_id` varchar(225) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `pay_price` decimal(10,0) DEFAULT NULL,
  `pay_type` int(11) DEFAULT NULL,
  `pay_way` int(11) DEFAULT NULL,
  `pay_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`,`order_Id`),
  KEY `order_Id` (`order_Id`),
  KEY `user_id` (`user_id`),
  KEY `user_id_2` (`user_id`),
  KEY `user_id_3` (`user_id`),
  CONSTRAINT `orderinfo_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user_auths` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `orderInfo`
-- ----------------------------
BEGIN;
INSERT INTO `orderInfo` VALUES ('24', '922016131388182528', null, '1502867110992', '100', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `order_detail`
-- ----------------------------
DROP TABLE IF EXISTS `order_detail`;
CREATE TABLE `order_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` varchar(22) DEFAULT NULL,
  `pkg_id` varchar(22) DEFAULT NULL,
  `order_status` varchar(225) DEFAULT NULL,
  `title` varchar(225) DEFAULT NULL,
  `pay_price` decimal(10,0) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_id` (`order_id`),
  KEY `pkg_id` (`pkg_id`),
  CONSTRAINT `order_detail_ibfk_3` FOREIGN KEY (`order_id`) REFERENCES `orderInfo` (`order_Id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `order_detail_ibfk_4` FOREIGN KEY (`pkg_id`) REFERENCES `package` (`pkg_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `package`
-- ----------------------------
DROP TABLE IF EXISTS `package`;
CREATE TABLE `package` (
  `id` int(11) NOT NULL,
  `pkg_id` varchar(22) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pkg_id` (`pkg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `package_detail`
-- ----------------------------
DROP TABLE IF EXISTS `package_detail`;
CREATE TABLE `package_detail` (
  `id` int(11) NOT NULL,
  `pkg_id` varchar(22) NOT NULL,
  `sku_id` varchar(22) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `price` decimal(10,0) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`,`pkg_id`),
  KEY `pkg_id` (`pkg_id`),
  KEY `sku_id` (`sku_id`),
  CONSTRAINT `package_detail_ibfk_3` FOREIGN KEY (`pkg_id`) REFERENCES `package` (`pkg_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `package_detail_ibfk_4` FOREIGN KEY (`sku_id`) REFERENCES `shop_product_sku` (`skuId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `shop_arrtK_cate`
-- ----------------------------
DROP TABLE IF EXISTS `shop_arrtK_cate`;
CREATE TABLE `shop_arrtK_cate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `arrtKId` bigint(20) DEFAULT NULL,
  `cateId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `shop_attr`
-- ----------------------------
DROP TABLE IF EXISTS `shop_attr`;
CREATE TABLE `shop_attr` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `attrId` varchar(20) DEFAULT NULL,
  `productId` varchar(20) DEFAULT NULL,
  `skuId` varchar(20) DEFAULT NULL,
  `k_id` varchar(20) DEFAULT NULL,
  `v_id` varchar(20) DEFAULT NULL,
  `isSku` int(11) DEFAULT NULL,
  `creatTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `k_id` (`k_id`),
  KEY `v_id` (`v_id`),
  KEY `productId` (`productId`),
  KEY `skuId` (`skuId`),
  CONSTRAINT `shop_attr_ibfk_6` FOREIGN KEY (`k_id`) REFERENCES `shop_attr_k` (`k_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `shop_attr_ibfk_7` FOREIGN KEY (`v_id`) REFERENCES `shop_attr_v` (`v_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `shop_attr_ibfk_8` FOREIGN KEY (`skuId`) REFERENCES `shop_product_sku` (`skuId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `shop_attr_ibfk_9` FOREIGN KEY (`productId`) REFERENCES `shop_product` (`productId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `shop_attr`
-- ----------------------------
BEGIN;
INSERT INTO `shop_attr` VALUES ('30', '898053517624635392', '897745410625134592', '898043823585787904', '897743694688960512', '898037381860052992', '1', '2017-08-17 13:26:58'), ('31', '898053738165334016', '897745410625134592', '898043823585787904', '897743730852249600', '898037787885457408', '1', '2017-08-17 13:27:51'), ('32', '898053857778495488', '897745410625134592', '898043823585787904', '897743752255782912', '898037570628898816', '1', '2017-08-17 13:28:19'), ('33', '898053999734714368', '897745410625134592', '898043823585787904', '898036492503891968', '898036987524173824', '1', '2017-08-17 13:28:53'), ('34', '898055005331681280', '897745410625134592', '898045343760941056', '897743694688960512', '898037381860052992', '1', '2017-08-17 13:32:53'), ('35', '898055199469236224', '897745410625134592', '898045343760941056', '897743752255782912', '898037602170064896', '1', '2017-08-17 13:33:39'), ('36', '898055322593030144', '897745410625134592', '898045343760941056', '897743730852249600', '898037787885457408', '1', '2017-08-17 13:34:09'), ('37', '898055432899031040', '897745410625134592', '898045343760941056', '898036492503891968', '898036987524173824', '1', '2017-08-17 13:34:35'), ('38', '898055615296729088', '897745410625134592', '898055480919752704', '897743694688960512', '898037381860052992', '1', '2017-08-17 13:35:18'), ('39', '898055735669059584', '897745410625134592', '898055480919752704', '897743752255782912', '898037587490000896', '1', '2017-08-17 13:35:47'), ('40', '898055858943848448', '897745410625134592', '898055480919752704', '897743730852249600', '898037800757776384', '1', '2017-08-17 13:36:17'), ('41', '898055958696980480', '897745410625134592', '898055480919752704', '898036492503891968', '898037003558998016', '1', '2017-08-17 13:36:40'), ('42', '898056441897578496', '897745410625134592', '898056326977978368', '897743694688960512', '898037450512420864', '1', '2017-08-17 13:38:35'), ('43', '898056608235286528', '897745410625134592', '898056326977978368', '897743752255782912', '898037570628898816', '1', '2017-08-17 13:39:15'), ('44', '898056737155608576', '897745410625134592', '898056326977978368', '897743730852249600', '898037787885457408', '1', '2017-08-17 13:39:46'), ('45', '898056945507659776', '897745410625134592', '898056326977978368', '898036492503891968', '898036987524173824', '1', '2017-08-17 13:40:36'), ('46', '898057282691952640', '897745410625134592', '898057120187973632', '897743694688960512', '898037450512420864', '1', '2017-08-17 13:41:56'), ('47', '898057957270253568', '897745410625134592', '898057120187973632', '897743752255782912', '898037602170064896', '1', '2017-08-17 13:44:37'), ('48', '898058061674868736', '897745410625134592', '898057120187973632', '897743730852249600', '898037787885457408', '1', '2017-08-17 13:45:02'), ('49', '898058166813487104', '897745410625134592', '898057120187973632', '898036492503891968', '898036987524173824', '1', '2017-08-17 13:45:27'), ('50', '898058448641355776', '897745410625134592', '898058226024611840', '897743694688960512', '898037450512420864', '1', '2017-08-17 13:46:34'), ('51', '898058542736371712', '897745410625134592', '898058226024611840', '897743752255782912', '898037587490000896', '1', '2017-08-17 13:46:56'), ('52', '898058650982969344', '897745410625134592', '898058226024611840', '897743730852249600', '898037800757776384', '1', '2017-08-17 13:47:22'), ('53', '898058757451182080', '897745410625134592', '898058226024611840', '898036492503891968', '898037003558998016', '1', '2017-08-17 13:47:48');
COMMIT;

-- ----------------------------
--  Table structure for `shop_attr_k`
-- ----------------------------
DROP TABLE IF EXISTS `shop_attr_k`;
CREATE TABLE `shop_attr_k` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `k_id` varchar(20) DEFAULT NULL,
  `k_Name` varchar(20) DEFAULT NULL,
  `cateid` varchar(20) DEFAULT '0',
  `isAlias` int(11) NOT NULL DEFAULT '0',
  `isColor` int(11) NOT NULL DEFAULT '0',
  `isEnmu` int(11) NOT NULL DEFAULT '0',
  `isInput` int(11) NOT NULL DEFAULT '0',
  `isKey` int(11) NOT NULL DEFAULT '0',
  `isSale` int(11) NOT NULL DEFAULT '0',
  `isSearch` int(11) NOT NULL DEFAULT '0' COMMENT '是否搜索',
  `isRequire` int(11) NOT NULL DEFAULT '0',
  `isMuti` int(11) NOT NULL DEFAULT '0',
  `state` int(11) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  `createtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `k_id` (`k_id`),
  KEY `cateid` (`cateid`),
  CONSTRAINT `shop_attr_k_ibfk_1` FOREIGN KEY (`cateid`) REFERENCES `shop_category` (`cateId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `shop_attr_k`
-- ----------------------------
BEGIN;
INSERT INTO `shop_attr_k` VALUES ('49', '897743666155110400', '尺寸', '897743530045480960', '0', '1', '0', '0', '0', '0', '0', '0', '0', null, '1', null), ('50', '897743694688960512', '颜色', '897743530045480960', '0', '1', '0', '0', '0', '0', '0', '0', '0', null, '1', null), ('51', '897743730852249600', '内存', '897743530045480960', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, '3', null), ('52', '897743752255782912', '容量', '897743530045480960', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, '2', null), ('53', '898036492503891968', '电池容量', '897743530045480960', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, '4', null), ('54', '924985506432303104', '电池444量', '897743530045480960', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null), ('55', '924985509934546944', '电池444量', '897743530045480960', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null), ('56', '924985513235464192', '电池444量', '897743530045480960', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `shop_attr_v`
-- ----------------------------
DROP TABLE IF EXISTS `shop_attr_v`;
CREATE TABLE `shop_attr_v` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `v_id` varchar(20) NOT NULL,
  `v_Name` varchar(20) DEFAULT NULL,
  `k_id` varchar(20) DEFAULT NULL,
  `state` int(11) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  `cateId` varchar(20) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `v_id` (`v_id`),
  KEY `k_id` (`k_id`),
  KEY `cateId` (`cateId`),
  CONSTRAINT `shop_attr_v_ibfk_3` FOREIGN KEY (`k_id`) REFERENCES `shop_attr_k` (`k_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `shop_attr_v_ibfk_4` FOREIGN KEY (`cateId`) REFERENCES `shop_category` (`cateId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `shop_attr_v`
-- ----------------------------
BEGIN;
INSERT INTO `shop_attr_v` VALUES ('12', '898036987524173824', '2000am', '898036492503891968', null, '1', null, '2017-08-17 12:21:17'), ('13', '898037003558998016', '4000am', '898036492503891968', null, '2', null, '2017-08-17 12:21:21'), ('14', '898037381860052992', '玫瑰金', '897743694688960512', null, '1', null, '2017-08-17 12:22:51'), ('15', '898037450512420864', '深空灰', '897743694688960512', null, '2', null, '2017-08-17 12:23:08'), ('16', '898037482531737600', '深色黑', '897743694688960512', null, '5', null, '2017-08-17 12:23:15'), ('17', '898037570628898816', '64G', '897743752255782912', null, '2', null, '2017-08-17 12:23:36'), ('18', '898037587490000896', '128G', '897743752255782912', null, '3', null, '2017-08-17 12:23:40'), ('19', '898037602170064896', '32G', '897743752255782912', null, '1', null, '2017-08-17 12:23:44'), ('20', '898037787885457408', '2G', '897743730852249600', null, '2', null, '2017-08-17 12:24:28'), ('21', '898037800757776384', '1G', '897743730852249600', null, '1', null, '2017-08-17 12:24:31');
COMMIT;

-- ----------------------------
--  Table structure for `shop_brand`
-- ----------------------------
DROP TABLE IF EXISTS `shop_brand`;
CREATE TABLE `shop_brand` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `brandId` varchar(20) DEFAULT NULL,
  `cateId` varchar(20) DEFAULT NULL,
  `name_cn` varchar(20) DEFAULT NULL,
  `name_en` varchar(20) DEFAULT NULL,
  `braDesc` text,
  `logo` varchar(255) DEFAULT NULL,
  `braState` varchar(10) DEFAULT NULL,
  `addr` varchar(255) DEFAULT NULL,
  `story` text,
  `creatTime` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `brandId` (`brandId`),
  KEY `brandId_2` (`brandId`),
  KEY `cateId` (`cateId`),
  CONSTRAINT `shop_brand_ibfk_1` FOREIGN KEY (`cateId`) REFERENCES `shop_category` (`cateId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `shop_brand`
-- ----------------------------
BEGIN;
INSERT INTO `shop_brand` VALUES ('1', '897725796758990848', '897743496109367296', '苹果', 'Apple', '滋源——无硅油头皮护理品牌，以天然洗护产品，让头皮重现健康年轻状态，秀发绽放健康之美。', 'https://baike.baidu.com/item/滋源/15623853?fr=aladdin', null, null, null, null), ('7', '902198452006825984', '897743496109367296', '小米', 'MI', '北京小米科技有限责任公司，成立于2010年4月，是一家专注于智能硬件和电子产品研发的移动互联网公司。“为发烧而生”是小米的产品概念。小米公司首创了用互联网模式开发手机操作系统、发烧友参与开发改进的模式', 'https://ss0.bdstatic.com/-0U0bnSm1A5BphGlnYG/tam-ogel/1e34aef2a409119018a4c6258e39ecfb_222_222.png', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `shop_category`
-- ----------------------------
DROP TABLE IF EXISTS `shop_category`;
CREATE TABLE `shop_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cateId` varchar(20) DEFAULT NULL,
  `cateName` varchar(20) DEFAULT NULL,
  `superId` varchar(20) DEFAULT NULL,
  `isSuper` int(11) DEFAULT NULL,
  `sortId` int(30) DEFAULT NULL,
  `deep` int(11) DEFAULT NULL COMMENT '深度',
  PRIMARY KEY (`id`),
  UNIQUE KEY `cateName` (`cateName`),
  KEY `superId` (`superId`),
  KEY `cateId` (`cateId`),
  CONSTRAINT `shop_category_ibfk_1` FOREIGN KEY (`superId`) REFERENCES `shop_category` (`cateId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `shop_category`
-- ----------------------------
BEGIN;
INSERT INTO `shop_category` VALUES ('49', '897743496109367296', '手机数码', null, '1', null, '0'), ('50', '897743530045480960', '手机', '897743496109367296', '0', null, '1'), ('52', '925364693848301568', '家居', null, '1', null, '0'), ('53', '925365027240943616', '电脑办公', null, '1', null, '0'), ('54', '925365084270895104', '玩具乐器', null, '1', null, '0'), ('55', '925370282993262592', '沙发', '925364693848301568', '0', null, '1'), ('58', '925370912327606272', '玩具乐', null, '1', null, '0'), ('59', '925371201571004416', 'ww', '925364693848301568', '0', null, '1');
COMMIT;

-- ----------------------------
--  Table structure for `shop_product`
-- ----------------------------
DROP TABLE IF EXISTS `shop_product`;
CREATE TABLE `shop_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `productId` varchar(20) DEFAULT NULL,
  `p_name` varchar(20) DEFAULT NULL,
  `brandId` varchar(20) DEFAULT NULL,
  `price` decimal(30,2) DEFAULT NULL,
  `creatTime` datetime DEFAULT NULL,
  `p_desc` varchar(225) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `productId` (`productId`),
  KEY `brandId` (`brandId`),
  CONSTRAINT `shop_product_ibfk_1` FOREIGN KEY (`brandId`) REFERENCES `shop_brand` (`brandId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `shop_product`
-- ----------------------------
BEGIN;
INSERT INTO `shop_product` VALUES ('17', '897745410625134592', 'iPhone 6s', '897725796758990848', '4500.00', '2017-08-16 17:02:40', '【限时2449元抢】Apple/苹果 iPhone 6 32G 全网通4G智能手机'), ('19', '902193321438109696', 'iPhone 5s', '897725796758990848', '1200.00', '2017-08-28 23:37:04', '苹果5s/送壳膜/12期分期/Apple/苹果 iPhone 5s 移动联通4G版手机'), ('20', '902194144645767168', 'iPhone 7', '897725796758990848', '4390.00', '2017-08-28 23:40:21', '苹果7【12期分期送壳膜】Apple/苹果 iPhone 7 全网通国行4G手机'), ('24', '902199496426676224', '小米5X', '902198452006825984', '1000.00', '2017-08-29 00:01:37', 'Xiaomi/小米 小米5X手机全新机官方正品双摄像头学生智能拍照手机'), ('26', '902200530632990720', '红米Note4X', '902198452006825984', '800.00', '2017-08-29 00:05:43', 'Xiaomi/小米 红米Note4X 32G/64G 指纹识别解锁拍照智能手机'), ('27', '902201800559190016', '小米MIX 尊享版', '902198452006825984', '6000.00', '2017-08-29 00:10:46', '【下单减500 可用120元券】Xiaomi/小米 小米MIX 尊享版现货'), ('34', '902204131115819008', '红米599', '902198452006825984', '599.56', '2017-08-29 00:20:02', 'Xiaomi/小米 红米手机4A 超长待机超薄迷你学生机智能机老人机');
COMMIT;

-- ----------------------------
--  Table structure for `shop_product_pic`
-- ----------------------------
DROP TABLE IF EXISTS `shop_product_pic`;
CREATE TABLE `shop_product_pic` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `picId` int(11) DEFAULT NULL,
  `url` varchar(50) DEFAULT NULL,
  `productId` varchar(20) DEFAULT NULL,
  `path` varchar(50) DEFAULT NULL,
  `isMain` int(11) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `productId` (`productId`),
  CONSTRAINT `shop_product_pic_ibfk_1` FOREIGN KEY (`productId`) REFERENCES `shop_product` (`productId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `shop_product_sku`
-- ----------------------------
DROP TABLE IF EXISTS `shop_product_sku`;
CREATE TABLE `shop_product_sku` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `skuId` varchar(20) DEFAULT NULL COMMENT '单品编码',
  `productId` varchar(20) DEFAULT NULL,
  `sku_name` varchar(225) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `outcode` float DEFAULT NULL,
  `state` int(11) DEFAULT NULL,
  `propertyStr` varchar(20) DEFAULT NULL,
  `barCode` int(11) DEFAULT NULL,
  `productCode` varchar(20) DEFAULT NULL,
  `creatTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `productId` (`productId`),
  KEY `skuId` (`skuId`),
  CONSTRAINT `shop_product_sku_ibfk_1` FOREIGN KEY (`productId`) REFERENCES `shop_product` (`productId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `shop_product_sku`
-- ----------------------------
BEGIN;
INSERT INTO `shop_product_sku` VALUES ('2', '898043823585787904', '897745410625134592', 'Iphone 6s 64G 1', '45', '6534', null, null, null, null, null, null), ('3', '898045343760941056', '897745410625134592', 'Iphone 6s 64G 2', '11', '7445', null, null, null, null, null, null), ('4', '898055480919752704', '897745410625134592', 'Iphone 6s 64G 3', '56', '9895', null, null, null, null, null, null), ('5', '898056326977978368', '897745410625134592', 'Iphone 6s 64G 4', '78', '654', null, null, null, null, null, null), ('6', '898057120187973632', '897745410625134592', 'Iphone 6s 64G 5', '450', '7895', null, null, null, null, null, null), ('7', '898058226024611840', '897745410625134592', 'Iphone 6s 深空灰 128G 1G 4000am', '44', '98789', null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `user_auths`
-- ----------------------------
DROP TABLE IF EXISTS `user_auths`;
CREATE TABLE `user_auths` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(225) NOT NULL COMMENT '系统用户id',
  `access_id` varchar(225) DEFAULT NULL COMMENT '第三方授权id',
  `credential` varchar(255) DEFAULT NULL,
  `platform` int(11) DEFAULT NULL,
  `creattime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `user_auths`
-- ----------------------------
BEGIN;
INSERT INTO `user_auths` VALUES ('1', '1502867110992', '1256489', '111111', '2', '2017-08-16 15:05:11'), ('2', '1503028290183', '111111', '111111', '0', '2017-08-18 11:51:30'), ('3', '1503385349184', 'D156BD9317750131976F9C8C2762A222', '004969976945D550E0CCDD00480B7E39', '1', '2017-08-22 15:02:29'), ('4', '1503936482074', 'o3LILj0ouJ7I7Noykthc-ovpw7sU', '_svN1LDk6G0lMpSnuuJ2KixQnFIsW-9sLd3b2vPqzRa7DeZ3cDNk1PvUtOLym3iiWJvJoMAIBq1LETcUOoZ4vhhI0fCKaN-me3wYMT6rGaE', '2', '2017-08-29 00:08:02'), ('5', '1509287965985', '88888', '111111', '0', '2017-10-29 22:39:26');
COMMIT;

-- ----------------------------
--  Table structure for `user_baseInfo`
-- ----------------------------
DROP TABLE IF EXISTS `user_baseInfo`;
CREATE TABLE `user_baseInfo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(225) NOT NULL COMMENT '系统用户id',
  `avatar` varchar(255) DEFAULT NULL,
  `nickname` varchar(255) DEFAULT NULL,
  `realname` varchar(255) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `sex` int(11) DEFAULT NULL,
  `birthday` datetime(6) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `user_baseinfo_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user_auths` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `user_baseInfo`
-- ----------------------------
BEGIN;
INSERT INTO `user_baseInfo` VALUES ('19', '1502867110992', null, null, null, null, null, null, null), ('20', '1503028290183', null, null, null, null, null, null, null), ('21', '1503385349184', 'https://bshop-user.oss-cn-shanghai.aliyuncs.com/123546875654/90499.jpg?size=400.400', '我们', null, null, '1', '2021-08-29 00:07:04.000000', null), ('22', '1503936482074', 'https://bshop-user.oss-cn-shanghai.aliyuncs.com/123546875654/66651.jpg?size=500.375', '明星款折扣', null, null, '1', '2015-10-13 21:41:23.000000', null), ('23', '1509287965985', null, null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `user_token`
-- ----------------------------
DROP TABLE IF EXISTS `user_token`;
CREATE TABLE `user_token` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(225) DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `device_id` varchar(255) DEFAULT NULL,
  `creattime` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `status_desc` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `user_token_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user_auths` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=448 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `user_token`
-- ----------------------------
BEGIN;
INSERT INTO `user_token` VALUES ('400', '1502867110992', '69b4183782a45c8ca4bd1f83f771e690', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 15:05:11', '1', '过期'), ('401', '1502867110992', '4b213926707ba30a9848fd515e79712f', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 16:42:17', '1', '过期'), ('402', '1502867110992', 'c617e9714b80b736864d82b57d5787a8', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:36:03', '1', '过期'), ('403', '1502867110992', '21a4c72e38042b54f55fa0f374eb97a3', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:02', '1', '过期'), ('404', '1502867110992', '004bb6b49d309a4279385fddd3050354', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:03', '1', '过期'), ('405', '1502867110992', '544653a013ac7b6c04a65896aef4d167', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:03', '1', '过期'), ('406', '1502867110992', 'df0c1f2cc569f6a5a8b6b2498e231a70', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:03', '1', '过期'), ('407', '1502867110992', '16e86207e7b8a2ea5d48a2965413d87e', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:03', '1', '过期'), ('408', '1502867110992', '0918e90f9587037eaa173a37685a0cda', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:03', '1', '过期'), ('409', '1502867110992', '82bf37face25c8cb6489fd1406218a96', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:03', '1', '过期'), ('410', '1502867110992', '0526a5f8bd08a716bd431a7db4eb830c', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:04', '1', '过期'), ('411', '1502867110992', '2187031e3bd97ea3d7ded9d61c772392', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:04', '1', '过期'), ('412', '1502867110992', '073ae771b0d2b134ba6dab35f860f6fd', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:04', '1', '过期'), ('413', '1502867110992', 'c94d06d7ea6ab4c5e1edc830005a0d7f', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:04', '1', '过期'), ('414', '1502867110992', '9db0894628a3dcd0ca747637c33a0a1a', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:05', '1', '过期'), ('415', '1502867110992', '1660923db7c8b981a601c2df2c1476db', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:05', '1', '过期'), ('416', '1502867110992', '53343833740961d96dab02702c758633', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:05', '1', '过期'), ('417', '1502867110992', 'ce49479692335d4c372c06b800ce3ecd', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:05', '1', '过期'), ('418', '1502867110992', '2f5dfa584e23fa2ba3bac9c438f798b2', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:05', '1', '过期'), ('419', '1502867110992', 'ef3981bebd90b398d8680b684c729113', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:06', '1', '过期'), ('420', '1502867110992', '234039b77f079e3f3d413aa3a78c292c', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:06', '1', '过期'), ('421', '1502867110992', 'e5b8d1b2bbcd3f44982f30f1e90dacfb', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:06', '1', '过期'), ('422', '1502867110992', '8bbb75ffa7e829db39f747c32c27eb25', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:06', '1', '过期'), ('423', '1502867110992', '9cdaafa80af13681e72394e873614b42', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:06', '1', '过期'), ('424', '1502867110992', '0a6732a2c64eb68b80f886c01633573f', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:07', '1', '过期'), ('425', '1502867110992', '8c8893b3b5eab0b1ebff340d2f5a98ae', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-16 17:47:24', '1', '过期'), ('426', '1502867110992', 'b7d128590dcaaeaa1a68e334da98b3d0', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-17 11:35:23', '1', '过期'), ('427', '1503028290183', '24a395078f682be993787e8e07f6385b', '192.168.0.101:8989', 'BShop/1.0 (iPhone; iOS 10.3; Scale/2.00)', '2017-08-18 11:51:40', '0', '正常'), ('428', '1502867110992', '3fbfd2e02e0c47f06c6b86e4397198b0', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-21 15:42:11', '1', '过期'), ('429', '1502867110992', '48e025a0ccd6eb5bf18cfe1121a2ea87', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-21 15:42:14', '1', '过期'), ('430', '1503385349184', 'ceabdd86e71b9fff72c4a5606628886a', '192.168.0.101:8989', 'BShop/1.0 (iPhone; iOS 10.3.2; Scale/2.00)', '2017-08-22 15:02:29', '1', '过期'), ('431', '1502867110992', '33c3079643751bdd94a7e88e9590514b', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-22 15:04:46', '1', '过期'), ('432', '1502867110992', '7a5e9101665ed3d29fe82b3c90100612', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-24 16:25:13', '1', '过期'), ('433', '1503385349184', '4cb56ce46dc832eb8c58d8119ac5f9fb', '192.168.0.101:8989', 'BShop/1.0 (iPhone; iOS 10.3.2; Scale/2.00)', '2017-08-24 20:49:35', '1', '过期'), ('434', '1503385349184', '6fc07cc67aa74bcd6b1f440cd0d52c1d', '192.168.0.101:8989', 'BShop/1.0 (iPhone; iOS 10.3.2; Scale/2.00)', '2017-08-28 16:38:07', '1', '过期'), ('435', '1502867110992', 'ecb4ad452284537f3fbbbc3cc3c3668f', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-28 22:36:50', '1', '过期'), ('436', '1503385349184', '0782f20900c9e55875477e6fe022796f', '192.168.0.101:8989', 'BShop/1.0 (iPhone; iOS 10.3.2; Scale/2.00)', '2017-08-28 23:01:21', '1', '过期'), ('437', '1502867110992', 'f0e2fd1face74f0178a13f988b9e0ceb', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.101 Safari/537.36', '2017-08-28 23:35:04', '1', '过期'), ('438', '1503936482074', '31059bf514f409107be571b6ab6739b1', '192.168.0.101:8989', 'BShop/1.0 (iPhone; iOS 10.3.2; Scale/2.00)', '2017-08-29 00:08:02', '1', '过期'), ('439', '1502867110992', 'a7fb2f4c62d9430c2be7d4316ee4b8d5', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36', '2017-10-13 21:35:18', '1', '过期'), ('440', '1502867110992', 'b41eeac667d574ba98a0bddc6d48b7c4', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36', '2017-10-13 21:36:35', '1', '过期'), ('441', '1503936482074', '284360aa9fdedf629cf148e5f321e866', '192.168.1.100:8989', 'BShop/1.0 (iPhone; iOS 10.3.3; Scale/2.00)', '2017-10-13 21:40:00', '1', '过期'), ('442', '1503936482074', 'f875b906feb7984e271b96971c5bdc2c', '192.168.1.100:8989', 'BShop/1.0 (iPhone; iOS 10.3.3; Scale/2.00)', '2017-10-13 21:40:48', '0', '正常'), ('443', '1502867110992', '94f54e0759e4e9448735aca30bedd19b', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36', '2017-10-22 16:03:52', '1', '过期'), ('444', '1502867110992', '12ff9881385642a70f2f8d9c37a72ae0', '127.0.0.1:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36', '2017-10-30 20:59:58', '1', '过期'), ('445', '1502867110992', '859f848674694e0e5356099d408a8ebb', '192.168.1.100:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36', '2017-10-31 22:08:17', '1', '过期'), ('446', '1502867110992', 'df7774e9f0b34fae8788eeefb8591aab', '192.168.1.100:8989', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36', '2017-10-31 22:09:31', '1', '过期'), ('447', '1502867110992', 'b68f1bfcb6b3f0471532036600de776f', '192.168.1.100:8989', 'PostmanRuntime/6.2.5', '2017-10-31 23:03:51', '0', '正常');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
